﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class new_year : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        ctpDataContext db = new ctpDataContext();
        var newyear = from p in db.ct_s_profiles
                      where p.title == "2008 New Year" && p.main_pic_fn != null && p.valid==true
                      select p;

        foreach (ct_s_profile c in newyear)
        {
            c.main_pic_fn = c.main_pic_fn.Trim();
        }

        this.GridView1.DataSource = newyear;
        this.DataBind();


    }
}
